package com.lin.sppringbootdemo.mapper;

import com.lin.sppringbootdemo.domain.TestLin;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Component
@Mapper
public interface TestLinMapper {
//    @Select("SELECT * FROM T_USER WHERE PHONE = #{phone}")
//    User findUserByPhone(@Param("phone") String phone);
//
//    @Insert("INSERT INTO T_USER(NAME, PASSWORD, PHONE) VALUES(#{name}, #{password}, #{phone})")
//    int insert(@Param("name") String name, @Param("password") String password, @Param("phone") String phone);

    @Select("select * from test_lin where id = #{id}")
    TestLin selectByID(@Param("id") int id);

    TestLin selectOneByID(int id);

}
